Finance ➔ VAT / Statistics ➔ VAT overview
You can view the information about the VAT that has been booked in the system through the VAT overview. The VAT entries are reflected by the types of VAT that include VAT to claim and VAT to pay, the corresponding VAT codes, and the number of VAT transactions that have been created. With the VAT overview, you can obtain a clear picture on the VAT entries and the balance amount of VAT to be paid or VAT to be claimed to or from the tax authorities.
The information in this document is applicable to product update 411 and higher. If you have versions lower than this, certain features explained here will not be applicable.
Select Date, Reporting date, or Fulfillment date to display the VAT overview by date, reporting date, or fulfilment date.
Depending on your selection, you will see Date, Reporting date, or Fulfilment date here. Type or select the date, reporting date, or fulfilment date range to display the VAT overview within the defined period range. Select the All check box to display the VAT overview for all the dates.
Note: Typing or selecting only the start date will display the VAT entries that are recorded on and after the selected date. Typing or selecting only the end date will display the VAT entries that are recorded on or before the selected date.
Select the type of VAT return you want to view. There are four options available:
Select the required option to group the VAT transactions:
This column displays the VAT box that is linked to the VAT code used in the entry. For more information, see Creating and maintaining VAT return boxes.
Note: This column is available only if you have selected VAT box / VAT code, VAT box, or Return period / VAT box at Group by.
This column displays the return period assigned to the entry.
Note: This column is available only if you have selected Return period / VAT box at Group by.
This column displays the VAT code that is used in the entry. For more information, see Creating and maintaining tax codes.
Note: This column is available only if you have selected VAT box / VAT code or VAT code at Group by.
This column displays the description of the VAT box that is linked to the VAT code used in the entry. For more information, see Creating and maintaining VAT return boxes.
This column displays description of the VAT code that is used in the entry. For more information, see Creating and maintaining tax codes.
This column displays the general ledger account in which the VAT is registered.
Note: This column is available only if you have selected GL account at Group by.
This column displays the description of the general ledger account in which the VAT is registered.
This column will display a checkmark when the Exclude from VAT return setting of the VAT box that is linked to the VAT code used in the entry is selected.
Note:
This column will display a checkmark when the Excl. from total in VAT overview setting of the VAT box that is linked to the VAT code used in the entry is selected.
This column displays the base amount on which the amount at VAT: To pay is based.
Note: This column is available only if you have selected Return period / VAT box or GL account at Group by.
This column displays the base amount on which the amount at VAT: To claim is based.
This column displays the VAT amount that has to be paid. This amount is based on the Basis: To pay amount and the VAT percentage.
This column displays the VAT amount that has to be claimed. This amount is based on the Basis: To claim amount and the VAT percentage.
This column displays the type of VAT which can be To claim, To pay or non-deductible VAT.
This column displays the base amount on which the amount at VAT is based.
Note: This column is available only if you have selected VAT box / VAT code, VAT box, or VAT code at Group by.
This column displays the total VAT amount. This amount is based on the VAT Basis amount and the VAT percentage.
This column displays the calculated VAT percentage. This is calculated based on the amounts in the VAT basis and VAT columns. Depending on how you group the overview and how you set up your company, this can be used as a control mechanism to compare the calculated VAT against the actual VAT percentage.
This column displays the actual VAT percentage. Depending on how you group the overview and how you set up your company, this can be used as a control mechanism to compare the calculated VAT against the actual VAT percentage.
This column displays the numbers of entries on which the amounts in the specific row in the overview are based. You can view the underlying entry lines by clicking the Zoom button.
The names of these columns are based on the VAT codes in your company. For every VAT code, a column is available that displays the VAT basis amount for that VAT code. For more information, see Creating and maintaining tax codes.
Note: This column is available only if you have selected VAT box, Return period / VAT box, or GL account at Group by.
Click this to display the VAT overview based on the defined criteria.
Click this to generate the print preview of the VAT overview.
Click this to view the transaction details of the selected VAT row in the overview.
Click this to export the data in the overview to Microsoft Excel.
Click this to assign the selected VAT transaction(s) to a tax period.
Click this to view the VAT returns that have been created in the system. For more information, see Overview of VAT return.
Click this to exit.